Tabela RumBlockedCard

Definicja tabeli RumBlockedCard

Name

RumBlockedCard

Code

RumBlockedCard

Comment

Zablokowane numery kart RUM


Lista kolumn tabeli RumBlockedCard

Name

Code

RumCardNumber

RumCardNumber

DuplicateNo

DuplicateNo

RumBlockReasonID

RumBlockReasonID

CardType

CardType

ExpireDT

ExpireDT

CancelDT

CancelDT

Active

Active

Insurer

Insurer

GenerateTime

GenerateTime

GenerateNo

GenerateNo

DataRange

DataRange

Version

Version


Kolumna RumCardNumber tabeli RumBlockedCard

Definicja kolumny RumCardNumber tabeli RumBlockedCard

Name

RumCardNumber

Code

RumCardNumber

Data Type

VARCHAR2(24)

Mandatory

Yes

Comment

Numer karty RUM


Kolumna DuplicateNo tabeli RumBlockedCard

Definicja kolumny DuplicateNo tabeli RumBlockedCard

Name

DuplicateNo

Code

DuplicateNo

Data Type

VARCHAR2(2)

Mandatory

Yes

Comment

Numer duplikatu


Kolumna RumBlockReasonID tabeli RumBlockedCard

Definicja kolumny RumBlockReasonID tabeli RumBlockedCard

Name

RumBlockReasonID

Code

RumBlockReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CardType tabeli RumBlockedCard

Definicja kolumny CardType tabeli RumBlockedCard

Name

CardType

Code

CardType

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Typ karty RUM


Kolumna ExpireDT tabeli RumBlockedCard

Definicja kolumny ExpireDT tabeli RumBlockedCard

Name

ExpireDT

Code

ExpireDT

Data Type

DATE

Mandatory

No

Comment

Data utraty waznosci karty RUM


Kolumna CancelDT tabeli RumBlockedCard

Definicja kolumny CancelDT tabeli RumBlockedCard

Name

CancelDT

Code

CancelDT

Data Type

DATE

Mandatory

No

Comment

Data uniewaznienia karty RUM


Kolumna Active tabeli RumBlockedCard

Definicja kolumny Active tabeli RumBlockedCard

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Insurer tabeli RumBlockedCard

Definicja kolumny Insurer tabeli RumBlockedCard

Name

Insurer

Code

Insurer

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Ubezpieczyciel


Kolumna GenerateTime tabeli RumBlockedCard

Definicja kolumny GenerateTime tabeli RumBlockedCard

Name

GenerateTime

Code

GenerateTime

Data Type

DATE

Mandatory

No

Comment

Data utworzenia karty RUM


Kolumna GenerateNo tabeli RumBlockedCard

Definicja kolumny GenerateNo tabeli RumBlockedCard

Name

GenerateNo

Code

GenerateNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DataRange tabeli RumBlockedCard

Definicja kolumny DataRange tabeli RumBlockedCard

Name

DataRange

Code

DataRange

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna Version tabeli RumBlockedCard

Definicja kolumny Version tabeli RumBlockedCard

Name

Version

Code

Version

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli RumBlockedCard

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli RumBlockedCard

Definicja klucza Identifier_1 tabeli RumBlockedCard

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment